Release 10.1A: OpenEdge Data Management:
SQL Reference

CONNECT

Establishes a connection to a database. Optionally, the CONNECT statement can also specify a name for the connection and a username and password for authentication.

Syntax

CONNECT TO connect_string [ AS connection_name ] [ USER username ] [ USING password ] ;

connect_string

Syntax

{ DEFAULT | db_name | db_type:T:host_name:port_num:db_name }

Note: Arguments to CONNECT must be either string literals enclosed in quotation marks or character-string host variables.

connect_string

Specifies to which database to connect. If the CONNECT statement specifies DEFAULT, SQL tries to connect to the environment-defined database, if any. The value of the DB_NAME environment variable specifies the default connect string.

The connect_string can be a simple database name or a complete connect_string. A complete connect string has the following components:

Connect string	Description
db_type	Type of database. The only currently supported database type is progress.
T	T directs the SQL engine to use the TCP/IP protocol.
host_name	Name of the system where the database resides.
port_num	Port number to use for the connection.
db_name	Name of the database.

connection_name

The name of the connection as either a character literal or host variable. If the CONNECT statement omits a connection name, the default is the name of the database. Connection names must be unique.

username

User name for authentication of the connection. SQL verifies the user name against a corresponding password before it connects to the database. The value of the DH_USER environment variable specifies the default user name. If DH_USER is not set, the value of the USER environment variable specifies the default user name.

password

Password for authentication of the connection. SQL verifies the password against a corresponding user name before it connects to the database.

The value of the DH_PASSWD environment variable determines the default password.

Notes

Arguments to CONNECT must be either string literals enclosed in quotation marks or character string host variables.
An application can connect to more than one database at a time, with a maximum of 10 connections. However, the application can actually gain access to only one database at a time. The database name specified in the CONNECT statement becomes the active one.
If an application executes a SQL statement before connecting to a database, an attempt is made to connect to the environment-defined database, if any. If the connection is successful, the SQL statement is executed on that database.

Examples

The following example illustrates the CONNECT statement:

CONNECT TO "salesdb" AS "sales_conn"; CONNECT TO "progress:T:localhost:custdb" AS "cust_conn"; CONNECT TO DEFAULT;

The first statement shown connects to the salesdb database on the local system.
The second statement connects to the custdb database on the local system.
The last statement connects to the environment-defined database by default.

Authorization

None

Related statements

DISCONNECT, SET CONNECTION